There are several loops that can be done but this is my favorite:
Follow the gravel doubletrack until it forks, and take the right path. Wind your way up and up, past two waterfalls, until you reach where the trail intersects the gravel road. Go left (and down!) and follow this back to the first waterfall and then ride out.
You can also turn right and go up the trail and come back down at where the gravel double-track forked at the beginning. Just make sure to make the turn and don't go on Farlow Gap Trail and away from your car! Also be prepaired to stop for some wooden steps, and after them, lots of people.
From Asheville, NC take I-26 to NC-280 South. Follow NC-289 to Brevard. Turn right onto US-276 into Pisgah National Forest. Turn left at fork right after bridge and drive past the fish hatchery and to the second gated road after it turns into gravel.
http://www.singletracks.com/item.php?c=1&i=997